package dex.micros_gdc.common

class SQLConstants {
	final static DEV_QUERY = "SELECT name FROM Resource WHERE role in ('DEV', 'TM') AND status = 'Active' ORDER BY name"
	final static QA_QUERY = "SELECT name FROM Resource WHERE role = 'QA' AND status = 'Active' ORDER BY name"
	final static PROJECT_QUERY = "SELECT name FROM Project ORDER BY name"
	final static VALID_PROJECT_QUERY = "SELECT distinct projectName FROM Task WHERE closedFlag = 'N'"
	final static TODAY_TASK_RECEIVED_QUERY = "SELECT projectName, COUNT(projectName) FROM Task WHERE receivedDate = ?  GROUP BY projectName ORDER BY projectName"
	final static ALL_DEV_QUERY = "SELECT name FROM Resource WHERE role in ('DEV', 'TM') ORDER BY name"
	final static ALL_QA_QUERY = "SELECT name FROM Resource WHERE role = 'QA' ORDER BY name"
	final static ALL_ACTIVE_RESOURCES_QUERY="SELECT name FROM Resource WHERE status = 'Active' ORDER BY name"
	final static NEXT_NEW_TASK_ID = "FROM Task t1 where t1.id = (select MAX(t2.id) from Task t2)";
}
